package com.ocom.human.dao;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ocom.common.entity.master.EntityMngUserInfo;
import com.ocom.common.entity.master.EntityWechatPerInfo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;


@Mapper
public interface IDaoWechatPerInfo extends BaseMapper<EntityWechatPerInfo> {

	@Select({"<script>",
			"SELECT  p.*  from mng_user_info p \n" +
					"left join wechat_per_info w on p.com_id=w.com_id and p.id=w.p_id \n" +
					"where w.appid=#{appId} and w.openid=#{openId} "+
					"</script>"}
	)
	public List<EntityMngUserInfo> getWxAdminInfo(String appId, String openId);

}
